﻿CREATE PROCEDURE dbo.SP_MemberPhones_Insert
	@MemberId Int   =  NULL 
		, @Phone VarChar (50)  =  NULL 
		, @PhoneType TinyInt   =  NULL 
		AS
			INSERT INTO MemberPhones
			(
									MemberId
												,Phone
												,PhoneType
									)
			Values(
									@MemberId
												,@Phone
												,@PhoneType
						)
			return @@identity